<?php
defined( '_VALID_MOS' ) or die('<script>window.location.href="http://www.kinifurniture.com";</script>');

$adm_functions->is_admin_login();
$section='Edit Collection';
$icon_description='
<table><tr><td>
	<table cellspacing="0" cellpadding="4" border="0" align="center">
		<tr align="center">
			<td>
				<img src="show_files/publish1.png" border="0" alt="Pending" />
			</td>
			<td>
				News is <u>inactive</u> |
			</td>
			<td>
				<img src="show_files/tick.png" border="0" alt="Visible" />
			</td>
			<td>
				News is <u>active</u>  |
			</td>
			<td>
				<img src="show_files/delete.png" border="0" alt="Visible" />
			</td>
			<td>
				<u>Delete</u> News
			</td>
		</tr>
	</table>
</td></tr><tr><td align="center">
	<table cellspacing="0" cellpadding="4" border="0" align="center">
		<tr align="center">
			<td align="center">
				<i>Click on icon to toggle state or execute command.</i>
			</td>
		</tr>
	</table>
</td></tr></table>
';
$adm_menu='
<table width="100%" class="menubar" cellpadding="0" cellspacing="0" border="0">
	<tr>
		<td class="menudottedline" width="40%">
			<div class="pathway"><img src="assets/admin/'.$SITE_LOGO_ADMIN.'"/></div>	</td>
		<td class="menudottedline" align="right">
			<table cellpadding="0" cellspacing="0" border="0" id="toolbar">
				<tr valign="middle" align="center">
					<td>&nbsp;</td>
					<td>
					<a class="toolbar" href="javascript:kliksubmit();">
						<img src="show_files/save.png"  alt="Save" name="save" title="Save" align="middle" border="0" />				<br />Save</a>
					</td>
					<td>&nbsp;</td>
					<td>
						<a class="toolbar" href="admin.php?show=collection_manager">
						<img src="show_files/cancel.png"  alt="Cancel" name="cancel" title="Cancel" align="middle" border="0" />				<br />Cancel</a>
					</td>
				</tr>
			</table>
		</td>
	</tr>
</table>
<br />
';

if ($id)
{
	$qryedit="select * from koleksi where id=$id";
	$selectedit=$dbh->query($qryedit);

	while($sqlRowedit=mysql_fetch_object($selectedit))
	{
		$val_id_collection=$sqlRowedit->id;
		$val_title=$sqlRowedit->nama;
		$val_description=$sqlRowedit->deskripsi;
		$val_img_collection=$sqlRowedit->image;
		if ($val_img_collection=='') $val_img_collection='noimg.png';
		if ($val_img_collection=='' || $val_img_collection=='noimg.png')
			$image='<input type="file" name="inp_upl_img"/>';
		else
			$image='<input class="inputbox" type="checkbox" name="inp_del_img" value="Y" /> Delete this image <font color="green">('.$val_img_collection.')</font>';
		$val_indoor=$sqlRowedit->indoor;
		$val_outdoor=$sqlRowedit->outdoor;
		$val_typeofwood=$sqlRowedit->typeofwood;
	if ($val_typeofwood=='EOW') $val_select5='selected';
	if ($val_typeofwood=='RTW') $val_select6='selected';
	if ($val_typeofwood=='VTW') $val_select7='selected';

		if ($sqlRowedit->indoor=='Y') 
		{
			$val_select1='selected';
			$val_select2='';
		}
			else 
		{
			$val_select1='';
			$val_select2='selected';
		}
		if ($sqlRowedit->outdoor=='Y') 
		{
			$val_select3='selected';
			$val_select4='';
		}
			else 
		{
			$val_select3='';
			$val_select4='selected';
		}
	}
}

if($inp_title)
{
//echo "<script>alert('$inp_upl_img');</script>";
	if ($inp_del_img=='Y')
	{
		$dbh->query("update koleksi set 
			nama='$inp_title', 
			indoor='$inp_indoor',
			outdoor='$inp_outdoor',
			typeofwood='$inp_typeofwood',
			image='',
			deskripsi='$inp_description'
			where id=$inp_id");
		@unlink("assets/collection/".$inp_image);
		echo '<script>window.location.href="admin.php?show=collection_manager";</script>';

	} else
	{
//$target = "upload/"; 
//$target = $target . basename( $_FILES['inp_img_uploaded']['name']) ; 
//$ok=1; 
//if(move_uploaded_file($_FILES['inp_img_uploaded']['tmp_name'], $target)) 
//{
//echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded";
//} 
//else {
//echo "Sorry, there was a problem uploading your file.";
//}


	if($_FILES['inp_upl_img']['name'])
	{
		$imageexists='N';
		$img_name=basename($_FILES['inp_upl_img']['name']);
		$qryname="select * from koleksi where image='$img_name'";
		$selectname=$dbh->query($qryname);
		while($sqlRowedit=mysql_fetch_object($selectname))
		{
			$imageexists='Y';
		}
		if ($imageexists=='Y') 
		{
			echo '<script>alert("The Filename is already exists, try another filename");</script>';
		}
		else
		{
			$uploaddir = 'assets/collection/';
			$uploadfile = $uploaddir . basename($_FILES['inp_upl_img']['name']);
			move_uploaded_file($_FILES['inp_upl_img']['tmp_name'], $uploadfile);
			$img_name=basename($_FILES['inp_upl_img']['name']);
			$qry_image='image=\''.$img_name.'\',';
		}
	} else 	$qry_image='';

	if ($imageexists!='Y')
		{
	$dbh->query("update koleksi set 
		nama='$inp_title',
		indoor='$inp_indoor',
		outdoor='$inp_outdoor',
		typeofwood='$inp_typeofwood',
		$qry_image
		deskripsi='$inp_description'
		where id=$inp_id");
	echo '<script>window.location.href="admin.php?show=collection_manager";</script>';
	}
	}
}
?>